INSERT INTO NavigantPortal.dbo.WebSite
(
	SiteCollectionID,
	SiteCollectionName,
	WebID,
	WebName,
	FullUrl
)
SELECT
	w.SiteId,
	(SELECT Title FROM Webs WHERE Id = s.RootWebId),
	w.Id,
	w.Title,
	w.FullUrl
FROM
	Webs w INNER JOIN Sites s
	ON w.SiteId = s.Id
	